package com.hwua.tonyshop.criteria;
	
import com.slkj.autocode.entity.Page;
import com.hwua.tonyshop.entity.pojo.GoodsInfo;

/**
* 
* @author sunny Yang [杨松彦]
* @QQ 550358261
* @date 2018-04-16
* @discribe
* >、<、>=、<=、=、!=、like、
* is null、is not null、in、not in
*
*/
public class GoodsInfoCriteria extends GoodsInfo{
	/**
	* 版本号
	*/
	private static final long serialVersionUID = 1L;
	private String groupBy123;//分组
	private String having123;//分组过滤
	private String orderBy123;//排序
	private Page page123;
	private String condition123="";//纯条件
	private String selectCondition123;//查询条件
	private String sql123;
	private GoodsInfo goodsInfo;
	private String feid123;//字段用于统计查询时设置

	public GoodsInfoCriteria() {

	}
	public String getFeid123() {
		return feid123;
	}
	public void setFeid123(String feid) {
		this.feid123 = feid;
	}
	public GoodsInfo getGoodsInfo() {
		return goodsInfo;
	}
	public void setGoodsInfo(GoodsInfo goodsInfo) {
		this.goodsInfo = goodsInfo;
		initGoodsInfo(goodsInfo);
	}

	public String getSql123() {
		return sql123;
	}

	public void setSql123(String sql123) {
		this.sql123 = sql123;
	}

	public String getSelectCondition123() {
		if(selectCondition123==null){
			if(condition123.trim().length()>0){
				condition123 = "where "+condition123;
			}
			selectCondition123 = condition123;
			if(groupBy123!=null){
				selectCondition123 += " group by "+groupBy123+" ";
			}
			if(having123!=null){
				selectCondition123 += "having "+having123+" ";
			}
			if(orderBy123!=null){
				selectCondition123 += "order by "+orderBy123+" ";
			}
			if(page123!=null){
				selectCondition123 += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
			}
			selectCondition123 = selectCondition123.trim();
		}
		System.out.println("查询条件："+selectCondition123);
		return selectCondition123;
	}
	public void setSelectCondition123(String selectCondition) {
		this.selectCondition123 = selectCondition;
	}
	public String getCondition123() {
		System.out.println("纯条件："+condition123);
		return condition123;
	}
	public void setCondition123(String condition) {
		this.condition123 = condition;
	}
	public GoodsInfoCriteria page(Page value){
		page123 = value;
		return this;
	}
	public GoodsInfoCriteria groupBy(String value){
		groupBy123 = value;
		return this;
	}
	public GoodsInfoCriteria having(String value){
		having123 = value;
		return this;
	}
	public GoodsInfoCriteria orderBy(String value){
		orderBy123 = value;
		return this;
	}

	/*public String getSqlAll(String tableName){
		String sql = "";
		if("where ".equals(condition123)){
			sql = "select * from `"+tableName+"` ";
		}else{
			sql = "select * from `"+tableName+"` "+condition123+" ";
		}
		if(groupBy123!=null){
			sql += sql+" group by "+groupBy123+" ";
		}
		if(having123!=null){
			sql += "having "+having123+" ";
		}
		if(orderBy123!=null){
			sql += "order by "+orderBy123+" ";
		}
		if(page123!=null){
			sql += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
		}
		sql = sql.trim();
		return sql; 
	}*/

/************以下为纯条件的拼接*******************/

	public GoodsInfoCriteria andIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `id` is null";
			}else{
				condition123 += "`id` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is null";
		}else{
			condition123 += "`id` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria andIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria andIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andNameEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`='"+name+"' ";
			}else{
				condition123 += "`name`='"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNameEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`='"+name+"' ";
			}else{
				condition123 += "`name`='"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameNotEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`!='"+name+"' ";
			}else{
				condition123 += "`name`!='"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameNotEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`!='"+name+"' ";
			}else{
				condition123 += "`name`!='"+name+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andNameGreaterThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`>'"+name+"' ";
			}else{
				condition123 += "`name`>'"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameGreaterThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`>'"+name+"' ";
			}else{
				condition123 += "`name`>'"+name+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andNameLessThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`<'"+name+"' ";
			}else{
				condition123 += "`name`<'"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameLessThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`<'"+name+"' ";
			}else{
				condition123 += "`name`<'"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameGreadterThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`>='"+name+"' ";
			}else{
				condition123 += "`name`>='"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameGreadterThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`>='"+name+"' ";
			}else{
				condition123 += "`name`>='"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameLessThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`<='"+name+"' ";
			}else{
				condition123 += "`name`<='"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameLessThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`<='"+name+"' ";
			}else{
				condition123 += "`name`<='"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameLike(String name){
		if(name!=null&&name.trim().length()>0&&!("%".equals(name.trim()))&&!("%%".equals(name.trim()))){
			if(condition123.length()>0){
				condition123 += "and `name` like '"+name+"' ";
			}else{
				condition123 += "`name` like '"+name+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNameLike(String name){
		if(name!=null&&name.trim().length()>0&&!("%".equals(name.trim()))&&!("%%".equals(name.trim()))){
			if(condition123.length()>0){
				condition123 += "or `name` like '"+name+"' ";
			}else{
				condition123 += "`name` like '"+name+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `name` is null";
			}else{
				condition123 += "`name` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `name` is null";
		}else{
			condition123 += "`name` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `name` is not null";
		}else{
			condition123 += "`name` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `name` is not null";
		}else{
			condition123 += "`name` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `name` in("+value+") ";
			}else{
				condition123 += "`name` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `name` in("+value+") ";
			}else{
				condition123 += "`name` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `name` not in("+value+") ";
			}else{
				condition123 += "`name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `name` not in("+value+") ";
			}else{
				condition123 += "`name` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andDescribeEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`='"+describe+"' ";
			}else{
				condition123 += "`describe`='"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orDescribeEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`='"+describe+"' ";
			}else{
				condition123 += "`describe`='"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeNotEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`!='"+describe+"' ";
			}else{
				condition123 += "`describe`!='"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeNotEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`!='"+describe+"' ";
			}else{
				condition123 += "`describe`!='"+describe+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andDescribeGreaterThan(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`>'"+describe+"' ";
			}else{
				condition123 += "`describe`>'"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeGreaterThan(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`>'"+describe+"' ";
			}else{
				condition123 += "`describe`>'"+describe+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andDescribeLessThan(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`<'"+describe+"' ";
			}else{
				condition123 += "`describe`<'"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeLessThan(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`<'"+describe+"' ";
			}else{
				condition123 += "`describe`<'"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeGreadterThanAndEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`>='"+describe+"' ";
			}else{
				condition123 += "`describe`>='"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeGreadterThanAndEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`>='"+describe+"' ";
			}else{
				condition123 += "`describe`>='"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeLessThanAndEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `describe`<='"+describe+"' ";
			}else{
				condition123 += "`describe`<='"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeLessThanAndEquals(String describe){
		if(describe!=null&&describe.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `describe`<='"+describe+"' ";
			}else{
				condition123 += "`describe`<='"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeLike(String describe){
		if(describe!=null&&describe.trim().length()>0&&!("%".equals(describe.trim()))&&!("%%".equals(describe.trim()))){
			if(condition123.length()>0){
				condition123 += "and `describe` like '"+describe+"' ";
			}else{
				condition123 += "`describe` like '"+describe+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeLike(String describe){
		if(describe!=null&&describe.trim().length()>0&&!("%".equals(describe.trim()))&&!("%%".equals(describe.trim()))){
			if(condition123.length()>0){
				condition123 += "or `describe` like '"+describe+"' ";
			}else{
				condition123 += "`describe` like '"+describe+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeIsNull(){
			if(condition123.length()>0){
				condition123 += "and `describe` is null";
			}else{
				condition123 += "`describe` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orDescribeIsNull(){
		if(condition123.length()>0){
			condition123 += "or `describe` is null";
		}else{
			condition123 += "`describe` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andDescribeIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `describe` is not null";
		}else{
			condition123 += "`describe` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orDescribeIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `describe` is not null";
		}else{
			condition123 += "`describe` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `describe` in("+value+") ";
			}else{
				condition123 += "`describe` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orDescribeIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `describe` in("+value+") ";
			}else{
				condition123 += "`describe` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDescribeNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `describe` not in("+value+") ";
			}else{
				condition123 += "`describe` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orDescribeNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `describe` not in("+value+") ";
			}else{
				condition123 += "`describe` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andOrgPriceEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`="+orgPrice+" ";
			}else{
				condition123 += "`org_price`="+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orOrgPriceEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`="+orgPrice+" ";
			}else{
				condition123 += "`org_price`="+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andOrgPriceNotEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`!="+orgPrice+" ";
			}else{
				condition123 += "`org_price`!="+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceNotEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`!="+orgPrice+" ";
			}else{
				condition123 += "`org_price`!="+orgPrice+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andOrgPriceGreaterThan(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`>"+orgPrice+" ";
			}else{
				condition123 += "`org_price`>"+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceGreaterThan(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`>"+orgPrice+" ";
			}else{
				condition123 += "`org_price`>"+orgPrice+" ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andOrgPriceLessThan(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`<"+orgPrice+" ";
			}else{
				condition123 += "`org_price`<"+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceLessThan(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`<"+orgPrice+" ";
			}else{
				condition123 += "`org_price`<"+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andOrgPriceGreadterThanAndEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`>="+orgPrice+" ";
			}else{
				condition123 += "`org_price`>="+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceGreadterThanAndEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`>="+orgPrice+" ";
			}else{
				condition123 += "`org_price`>="+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andOrgPriceLessThanAndEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price`<="+orgPrice+" ";
			}else{
				condition123 += "`org_price`<="+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceLessThanAndEquals(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price`<="+orgPrice+" ";
			}else{
				condition123 += "`org_price`<="+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andOrgPriceLike(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `org_price` like "+orgPrice+" ";
			}else{
				condition123 += "`org_price` like "+orgPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceLike(Integer orgPrice){
		if(orgPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `org_price` like "+orgPrice+" ";
			}else{
				condition123 += "`org_price` like "+orgPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andOrgPriceIsNull(){
			if(condition123.length()>0){
				condition123 += "and `org_price` is null";
			}else{
				condition123 += "`org_price` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceIsNull(){
		if(condition123.length()>0){
			condition123 += "or `org_price` is null";
		}else{
			condition123 += "`org_price` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andOrgPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `org_price` is not null";
		}else{
			condition123 += "`org_price` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `org_price` is not null";
		}else{
			condition123 += "`org_price` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria andOrgPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `org_price` in("+value+") ";
			}else{
				condition123 += "`org_price` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `org_price` in("+value+") ";
			}else{
				condition123 += "`org_price` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria andOrgPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `org_price` not in("+value+") ";
			}else{
				condition123 += "`org_price` not in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orOrgPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `org_price` not in("+value+") ";
			}else{
				condition123 += "`org_price` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andDisPriceEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`="+disPrice+" ";
			}else{
				condition123 += "`dis_price`="+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orDisPriceEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`="+disPrice+" ";
			}else{
				condition123 += "`dis_price`="+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDisPriceNotEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`!="+disPrice+" ";
			}else{
				condition123 += "`dis_price`!="+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceNotEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`!="+disPrice+" ";
			}else{
				condition123 += "`dis_price`!="+disPrice+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andDisPriceGreaterThan(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`>"+disPrice+" ";
			}else{
				condition123 += "`dis_price`>"+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceGreaterThan(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`>"+disPrice+" ";
			}else{
				condition123 += "`dis_price`>"+disPrice+" ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andDisPriceLessThan(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`<"+disPrice+" ";
			}else{
				condition123 += "`dis_price`<"+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceLessThan(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`<"+disPrice+" ";
			}else{
				condition123 += "`dis_price`<"+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDisPriceGreadterThanAndEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`>="+disPrice+" ";
			}else{
				condition123 += "`dis_price`>="+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceGreadterThanAndEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`>="+disPrice+" ";
			}else{
				condition123 += "`dis_price`>="+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDisPriceLessThanAndEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price`<="+disPrice+" ";
			}else{
				condition123 += "`dis_price`<="+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceLessThanAndEquals(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price`<="+disPrice+" ";
			}else{
				condition123 += "`dis_price`<="+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDisPriceLike(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `dis_price` like "+disPrice+" ";
			}else{
				condition123 += "`dis_price` like "+disPrice+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceLike(Integer disPrice){
		if(disPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `dis_price` like "+disPrice+" ";
			}else{
				condition123 += "`dis_price` like "+disPrice+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andDisPriceIsNull(){
			if(condition123.length()>0){
				condition123 += "and `dis_price` is null";
			}else{
				condition123 += "`dis_price` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orDisPriceIsNull(){
		if(condition123.length()>0){
			condition123 += "or `dis_price` is null";
		}else{
			condition123 += "`dis_price` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andDisPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `dis_price` is not null";
		}else{
			condition123 += "`dis_price` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `dis_price` is not null";
		}else{
			condition123 += "`dis_price` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria andDisPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `dis_price` in("+value+") ";
			}else{
				condition123 += "`dis_price` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `dis_price` in("+value+") ";
			}else{
				condition123 += "`dis_price` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria andDisPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `dis_price` not in("+value+") ";
			}else{
				condition123 += "`dis_price` not in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orDisPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `dis_price` not in("+value+") ";
			}else{
				condition123 += "`dis_price` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andHotSignEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`='"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orHotSignEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`='"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignNotEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`!='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`!='"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignNotEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`!='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`!='"+hotSign+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andHotSignGreaterThan(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`>'"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`>'"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignGreaterThan(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`>'"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`>'"+hotSign+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andHotSignLessThan(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`<'"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`<'"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignLessThan(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`<'"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`<'"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignGreadterThanAndEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`>='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`>='"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignGreadterThanAndEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`>='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`>='"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignLessThanAndEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `hot_sign`<='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`<='"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignLessThanAndEquals(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `hot_sign`<='"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign`<='"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignLike(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0&&!("%".equals(hotSign.trim()))&&!("%%".equals(hotSign.trim()))){
			if(condition123.length()>0){
				condition123 += "and `hot_sign` like '"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign` like '"+hotSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignLike(String hotSign){
		if(hotSign!=null&&hotSign.trim().length()>0&&!("%".equals(hotSign.trim()))&&!("%%".equals(hotSign.trim()))){
			if(condition123.length()>0){
				condition123 += "or `hot_sign` like '"+hotSign+"' ";
			}else{
				condition123 += "`hot_sign` like '"+hotSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignIsNull(){
			if(condition123.length()>0){
				condition123 += "and `hot_sign` is null";
			}else{
				condition123 += "`hot_sign` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orHotSignIsNull(){
		if(condition123.length()>0){
			condition123 += "or `hot_sign` is null";
		}else{
			condition123 += "`hot_sign` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andHotSignIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `hot_sign` is not null";
		}else{
			condition123 += "`hot_sign` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orHotSignIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `hot_sign` is not null";
		}else{
			condition123 += "`hot_sign` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `hot_sign` in("+value+") ";
			}else{
				condition123 += "`hot_sign` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orHotSignIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `hot_sign` in("+value+") ";
			}else{
				condition123 += "`hot_sign` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andHotSignNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `hot_sign` not in("+value+") ";
			}else{
				condition123 += "`hot_sign` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orHotSignNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `hot_sign` not in("+value+") ";
			}else{
				condition123 += "`hot_sign` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andNewSignEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`='"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNewSignEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`='"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignNotEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`!='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`!='"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignNotEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`!='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`!='"+newSign+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andNewSignGreaterThan(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`>'"+newSign+"' ";
			}else{
				condition123 += "`new_sign`>'"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignGreaterThan(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`>'"+newSign+"' ";
			}else{
				condition123 += "`new_sign`>'"+newSign+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andNewSignLessThan(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`<'"+newSign+"' ";
			}else{
				condition123 += "`new_sign`<'"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignLessThan(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`<'"+newSign+"' ";
			}else{
				condition123 += "`new_sign`<'"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignGreadterThanAndEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`>='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`>='"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignGreadterThanAndEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`>='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`>='"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignLessThanAndEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `new_sign`<='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`<='"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignLessThanAndEquals(String newSign){
		if(newSign!=null&&newSign.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `new_sign`<='"+newSign+"' ";
			}else{
				condition123 += "`new_sign`<='"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignLike(String newSign){
		if(newSign!=null&&newSign.trim().length()>0&&!("%".equals(newSign.trim()))&&!("%%".equals(newSign.trim()))){
			if(condition123.length()>0){
				condition123 += "and `new_sign` like '"+newSign+"' ";
			}else{
				condition123 += "`new_sign` like '"+newSign+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignLike(String newSign){
		if(newSign!=null&&newSign.trim().length()>0&&!("%".equals(newSign.trim()))&&!("%%".equals(newSign.trim()))){
			if(condition123.length()>0){
				condition123 += "or `new_sign` like '"+newSign+"' ";
			}else{
				condition123 += "`new_sign` like '"+newSign+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignIsNull(){
			if(condition123.length()>0){
				condition123 += "and `new_sign` is null";
			}else{
				condition123 += "`new_sign` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orNewSignIsNull(){
		if(condition123.length()>0){
			condition123 += "or `new_sign` is null";
		}else{
			condition123 += "`new_sign` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andNewSignIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `new_sign` is not null";
		}else{
			condition123 += "`new_sign` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orNewSignIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `new_sign` is not null";
		}else{
			condition123 += "`new_sign` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `new_sign` in("+value+") ";
			}else{
				condition123 += "`new_sign` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNewSignIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `new_sign` in("+value+") ";
			}else{
				condition123 += "`new_sign` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andNewSignNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `new_sign` not in("+value+") ";
			}else{
				condition123 += "`new_sign` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orNewSignNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `new_sign` not in("+value+") ";
			}else{
				condition123 += "`new_sign` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andClassIdEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`="+classId+" ";
			}else{
				condition123 += "`class_id`="+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orClassIdEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`="+classId+" ";
			}else{
				condition123 += "`class_id`="+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andClassIdNotEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`!="+classId+" ";
			}else{
				condition123 += "`class_id`!="+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdNotEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`!="+classId+" ";
			}else{
				condition123 += "`class_id`!="+classId+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andClassIdGreaterThan(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`>"+classId+" ";
			}else{
				condition123 += "`class_id`>"+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdGreaterThan(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`>"+classId+" ";
			}else{
				condition123 += "`class_id`>"+classId+" ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andClassIdLessThan(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`<"+classId+" ";
			}else{
				condition123 += "`class_id`<"+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdLessThan(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`<"+classId+" ";
			}else{
				condition123 += "`class_id`<"+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andClassIdGreadterThanAndEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`>="+classId+" ";
			}else{
				condition123 += "`class_id`>="+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdGreadterThanAndEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`>="+classId+" ";
			}else{
				condition123 += "`class_id`>="+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andClassIdLessThanAndEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id`<="+classId+" ";
			}else{
				condition123 += "`class_id`<="+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdLessThanAndEquals(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id`<="+classId+" ";
			}else{
				condition123 += "`class_id`<="+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andClassIdLike(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "and `class_id` like "+classId+" ";
			}else{
				condition123 += "`class_id` like "+classId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdLike(Integer classId){
		if(classId!=null){
			if(condition123.length()>0){
				condition123 += "or `class_id` like "+classId+" ";
			}else{
				condition123 += "`class_id` like "+classId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andClassIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `class_id` is null";
			}else{
				condition123 += "`class_id` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orClassIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `class_id` is null";
		}else{
			condition123 += "`class_id` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andClassIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `class_id` is not null";
		}else{
			condition123 += "`class_id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `class_id` is not null";
		}else{
			condition123 += "`class_id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria andClassIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `class_id` in("+value+") ";
			}else{
				condition123 += "`class_id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `class_id` in("+value+") ";
			}else{
				condition123 += "`class_id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria andClassIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `class_id` not in("+value+") ";
			}else{
				condition123 += "`class_id` not in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orClassIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `class_id` not in("+value+") ";
			}else{
				condition123 += "`class_id` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andMenuIdEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`="+menuId+" ";
			}else{
				condition123 += "`menu_id`="+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orMenuIdEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`="+menuId+" ";
			}else{
				condition123 += "`menu_id`="+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuIdNotEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`!="+menuId+" ";
			}else{
				condition123 += "`menu_id`!="+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdNotEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`!="+menuId+" ";
			}else{
				condition123 += "`menu_id`!="+menuId+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andMenuIdGreaterThan(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`>"+menuId+" ";
			}else{
				condition123 += "`menu_id`>"+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdGreaterThan(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`>"+menuId+" ";
			}else{
				condition123 += "`menu_id`>"+menuId+" ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andMenuIdLessThan(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`<"+menuId+" ";
			}else{
				condition123 += "`menu_id`<"+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdLessThan(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`<"+menuId+" ";
			}else{
				condition123 += "`menu_id`<"+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuIdGreadterThanAndEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`>="+menuId+" ";
			}else{
				condition123 += "`menu_id`>="+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdGreadterThanAndEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`>="+menuId+" ";
			}else{
				condition123 += "`menu_id`>="+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuIdLessThanAndEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id`<="+menuId+" ";
			}else{
				condition123 += "`menu_id`<="+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdLessThanAndEquals(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id`<="+menuId+" ";
			}else{
				condition123 += "`menu_id`<="+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuIdLike(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "and `menu_id` like "+menuId+" ";
			}else{
				condition123 += "`menu_id` like "+menuId+" ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdLike(Integer menuId){
		if(menuId!=null){
			if(condition123.length()>0){
				condition123 += "or `menu_id` like "+menuId+" ";
			}else{
				condition123 += "`menu_id` like "+menuId+" ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `menu_id` is null";
			}else{
				condition123 += "`menu_id` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orMenuIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `menu_id` is null";
		}else{
			condition123 += "`menu_id` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andMenuIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `menu_id` is not null";
		}else{
			condition123 += "`menu_id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `menu_id` is not null";
		}else{
			condition123 += "`menu_id` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria andMenuIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_id` in("+value+") ";
			}else{
				condition123 += "`menu_id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_id` in("+value+") ";
			}else{
				condition123 += "`menu_id` in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria andMenuIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_id` not in("+value+") ";
			}else{
				condition123 += "`menu_id` not in("+value+") ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_id` not in("+value+") ";
			}else{
				condition123 += "`menu_id` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andMenuNameEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`='"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orMenuNameEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`='"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameNotEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`!='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`!='"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameNotEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`!='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`!='"+menuName+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andMenuNameGreaterThan(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`>'"+menuName+"' ";
			}else{
				condition123 += "`menu_name`>'"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameGreaterThan(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`>'"+menuName+"' ";
			}else{
				condition123 += "`menu_name`>'"+menuName+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andMenuNameLessThan(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`<'"+menuName+"' ";
			}else{
				condition123 += "`menu_name`<'"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameLessThan(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`<'"+menuName+"' ";
			}else{
				condition123 += "`menu_name`<'"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameGreadterThanAndEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`>='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`>='"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameGreadterThanAndEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`>='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`>='"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameLessThanAndEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `menu_name`<='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`<='"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameLessThanAndEquals(String menuName){
		if(menuName!=null&&menuName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `menu_name`<='"+menuName+"' ";
			}else{
				condition123 += "`menu_name`<='"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameLike(String menuName){
		if(menuName!=null&&menuName.trim().length()>0&&!("%".equals(menuName.trim()))&&!("%%".equals(menuName.trim()))){
			if(condition123.length()>0){
				condition123 += "and `menu_name` like '"+menuName+"' ";
			}else{
				condition123 += "`menu_name` like '"+menuName+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameLike(String menuName){
		if(menuName!=null&&menuName.trim().length()>0&&!("%".equals(menuName.trim()))&&!("%%".equals(menuName.trim()))){
			if(condition123.length()>0){
				condition123 += "or `menu_name` like '"+menuName+"' ";
			}else{
				condition123 += "`menu_name` like '"+menuName+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `menu_name` is null";
			}else{
				condition123 += "`menu_name` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orMenuNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `menu_name` is null";
		}else{
			condition123 += "`menu_name` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andMenuNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `menu_name` is not null";
		}else{
			condition123 += "`menu_name` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orMenuNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `menu_name` is not null";
		}else{
			condition123 += "`menu_name` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `menu_name` in("+value+") ";
			}else{
				condition123 += "`menu_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orMenuNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `menu_name` in("+value+") ";
			}else{
				condition123 += "`menu_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andMenuNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `menu_name` not in("+value+") ";
			}else{
				condition123 += "`menu_name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orMenuNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `menu_name` not in("+value+") ";
			}else{
				condition123 += "`menu_name` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andTitleImgEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`='"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orTitleImgEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`='"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgNotEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`!='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`!='"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgNotEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`!='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`!='"+titleImg+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andTitleImgGreaterThan(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`>'"+titleImg+"' ";
			}else{
				condition123 += "`title_img`>'"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgGreaterThan(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`>'"+titleImg+"' ";
			}else{
				condition123 += "`title_img`>'"+titleImg+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andTitleImgLessThan(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`<'"+titleImg+"' ";
			}else{
				condition123 += "`title_img`<'"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgLessThan(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`<'"+titleImg+"' ";
			}else{
				condition123 += "`title_img`<'"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgGreadterThanAndEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`>='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`>='"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgGreadterThanAndEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`>='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`>='"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgLessThanAndEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `title_img`<='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`<='"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgLessThanAndEquals(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `title_img`<='"+titleImg+"' ";
			}else{
				condition123 += "`title_img`<='"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgLike(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0&&!("%".equals(titleImg.trim()))&&!("%%".equals(titleImg.trim()))){
			if(condition123.length()>0){
				condition123 += "and `title_img` like '"+titleImg+"' ";
			}else{
				condition123 += "`title_img` like '"+titleImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgLike(String titleImg){
		if(titleImg!=null&&titleImg.trim().length()>0&&!("%".equals(titleImg.trim()))&&!("%%".equals(titleImg.trim()))){
			if(condition123.length()>0){
				condition123 += "or `title_img` like '"+titleImg+"' ";
			}else{
				condition123 += "`title_img` like '"+titleImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgIsNull(){
			if(condition123.length()>0){
				condition123 += "and `title_img` is null";
			}else{
				condition123 += "`title_img` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orTitleImgIsNull(){
		if(condition123.length()>0){
			condition123 += "or `title_img` is null";
		}else{
			condition123 += "`title_img` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andTitleImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `title_img` is not null";
		}else{
			condition123 += "`title_img` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orTitleImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `title_img` is not null";
		}else{
			condition123 += "`title_img` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `title_img` in("+value+") ";
			}else{
				condition123 += "`title_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orTitleImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `title_img` in("+value+") ";
			}else{
				condition123 += "`title_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andTitleImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `title_img` not in("+value+") ";
			}else{
				condition123 += "`title_img` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orTitleImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `title_img` not in("+value+") ";
			}else{
				condition123 += "`title_img` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andGoodsImgEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`='"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orGoodsImgEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`='"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgNotEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`!='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`!='"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgNotEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`!='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`!='"+goodsImg+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andGoodsImgGreaterThan(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`>'"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`>'"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgGreaterThan(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`>'"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`>'"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andGoodsImgLessThan(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`<'"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`<'"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgLessThan(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`<'"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`<'"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgGreadterThanAndEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`>='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`>='"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgGreadterThanAndEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`>='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`>='"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgLessThanAndEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_img`<='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`<='"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgLessThanAndEquals(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_img`<='"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img`<='"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgLike(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0&&!("%".equals(goodsImg.trim()))&&!("%%".equals(goodsImg.trim()))){
			if(condition123.length()>0){
				condition123 += "and `goods_img` like '"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img` like '"+goodsImg+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgLike(String goodsImg){
		if(goodsImg!=null&&goodsImg.trim().length()>0&&!("%".equals(goodsImg.trim()))&&!("%%".equals(goodsImg.trim()))){
			if(condition123.length()>0){
				condition123 += "or `goods_img` like '"+goodsImg+"' ";
			}else{
				condition123 += "`goods_img` like '"+goodsImg+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgIsNull(){
			if(condition123.length()>0){
				condition123 += "and `goods_img` is null";
			}else{
				condition123 += "`goods_img` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgIsNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_img` is null";
		}else{
			condition123 += "`goods_img` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andGoodsImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `goods_img` is not null";
		}else{
			condition123 += "`goods_img` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orGoodsImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_img` is not null";
		}else{
			condition123 += "`goods_img` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `goods_img` in("+value+") ";
			}else{
				condition123 += "`goods_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orGoodsImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `goods_img` in("+value+") ";
			}else{
				condition123 += "`goods_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andGoodsImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `goods_img` not in("+value+") ";
			}else{
				condition123 += "`goods_img` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orGoodsImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `goods_img` not in("+value+") ";
			}else{
				condition123 += "`goods_img` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "and `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "or `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `create_date` is null";
			}else{
				condition123 += "`create_date` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orCreateDateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is null";
		}else{
			condition123 += "`create_date` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}

	public GoodsInfoCriteria andStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public GoodsInfoCriteria andStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	
	
	public GoodsInfoCriteria andStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "and `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	public GoodsInfoCriteria orStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "or `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `state` is null";
			}else{
				condition123 += "`state` is null";
			}
		return this;
	}
	public GoodsInfoCriteria orStateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is null";
		}else{
			condition123 += "`state` is null";
		}
		return this;
	}
	public GoodsInfoCriteria andStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	public GoodsInfoCriteria orStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria andStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}
	
	public GoodsInfoCriteria orStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}

	private void initGoodsInfo(GoodsInfo goodsInfo) {
		super.setId(goodsInfo.getId());
		super.setName(goodsInfo.getName());
		super.setDescribe(goodsInfo.getDescribe());
		super.setOrgPrice(goodsInfo.getOrgPrice());
		super.setDisPrice(goodsInfo.getDisPrice());
		super.setHotSign(goodsInfo.getHotSign());
		super.setNewSign(goodsInfo.getNewSign());
		super.setClassId(goodsInfo.getClassId());
		super.setMenuId(goodsInfo.getMenuId());
		super.setMenuName(goodsInfo.getMenuName());
		super.setTitleImg(goodsInfo.getTitleImg());
		super.setGoodsImg(goodsInfo.getGoodsImg());
		super.setCreateDate(goodsInfo.getCreateDate());
		super.setState(goodsInfo.getState());

	}

}